FaStudentAY

Logical Entity Name | FaStudentAY
Default Table Name | FaStudentAY
Physical Only | NO
Owner | dbo
Definition |
Note |

FaStudentAY Columns

ColumnName | Domain | Datatype | NULL | Definition
FAStudentAYID |  | int | NO |
AdEnrollID |  | int | NO |
FaAcademicYearID |  | int | NO |
FaProgramAYSeqID |  | int | NO |
AdGradeLevelID |  | int | NO |
FaBudgetID |  | int | YES |
Sequence |  | smallint | NO |
FaFAAID |  | int | YES |
StartDate |  | datetime | NO |
EndDate |  | datetime | NO |
AwardYear1 |  | char(7) | NO |
AwardYear2 |  | char(7) | YES |
FirstTimeBorrower |  | bit | NO |
PackageDate |  | datetime | YES |
FaPackStatusID |  | int | NO |
PackageRevised |  | bit | NO |
AwardNoticePrinted |  | datetime | YES |
AwardNoticeSigned |  | datetime | YES |
RevisedNoticePrinted |  | datetime | YES |
RevisedNoticeSigned |  | datetime | YES |
WeeksInAY |  | numeric(4, 1) | YES |
MonthsInAY |  | numeric(4, 1) | YES |
WeeksNonEnroll |  | numeric(4, 1) | YES |
CreditHoursInAY |  | numeric(7, 2) | YES |
CostOfAttend |  | money | YES |
Tuition |  | money | YES |
BooksSupplies |  | money | YES |
RoomBoard |  | money | YES |
Travel |  | money | YES |
OtherDescrip1 |  | varchar(40) | YES |
OtherAmount1 |  | money | YES |
OtherDescrip2 |  | varchar(40) | YES |
OtherAmount2 |  | money | YES |
OtherDescrip3 |  | varchar(40) | YES |
OtherAmount3 |  | money | YES |
OtherDescrip4 |  | varchar(40) | YES |
OtherAmount4 |  | money | YES |
PellCostOfAttend |  | money | YES |
WeeksEnrolledInAY |  | int | YES |
CreditHoursExpToComplete |  | numeric(9, 2) | YES |
Comment |  | varchar(4000) | YES |
DateBilled |  | datetime | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
InstitutionalCharges |  | money | YES |
FaPackMethID |  | int | YES |
OtherAmount5 |  | money | YES |
OtherAmount6 |  | money | YES |
OtherAmount7 |  | money | YES |
OtherAmount8 |  | money | YES |
OtherDescrip5 |  | char(40) | YES |
OtherDescrip6 |  | char(40) | YES |
OtherDescrip7 |  | char(40) | YES |
OtherDescrip8 |  | char(40) | YES |
OtherInst1 |  | bit | NO |
OtherInst2 |  | bit | NO |
OtherInst3 |  | bit | NO |
OtherInst4 |  | bit | NO |
OtherInst5 |  | bit | NO |
OtherInst6 |  | bit | NO |
OtherInst7 |  | bit | NO |
OtherInst8 |  | bit | NO |
AYComments |  | varchar(3000) | YES |
BankFees |  | money | NO |
BudgetRecordID |  | char(20) | YES |
PackagedToAdAttStatID |  | int | YES |
HousingStatusCode |  | char(1) | YES |
HybridDates |  | bit | NO |
AwardYear2FAPackStatusID |  | int | YES |
unsubeligibilityuptoheal |  | bit | NO |
TeachCounselingDate |  | datetime | YES |
UnsupportedDependent |  | bit | NO |
AutoAwardBudgetLock |  | bit | NO |
AutoAwardPackageLock |  | bit | NO |
AutoAwardEvaluationType |  | char(1) | YES |
AutoAwardRequestProcess |  | varchar(200) | YES |
HPPALevel |  | char(1) | NO |
PLUSCreditDecisionStatus |  | char(1) | YES |
ExcludeSummerPackaging |  | bit | NO |
FaAutoAwardPopulationConfigurationId |  | int | YES |
AutoAwardInitialCalculationDate |  | datetime | YES |
AutoAwardReAwardCalculationDate |  | datetime | YES |
ReentryAY |  | bit | YES |
ExcludeStartDate |  | bit | NO |
ExcludeEndDate |  | bit | NO |
CounselingCompleteDate |  | datetime | YES |
CounselingType |  | varchar(50) | YES |
AutoAwardAdAttStatId |  | int | YES |
IWINAY |  | numeric(4, 1) | NO |
IWMonths |  | numeric(4, 1) | NO |
RefWeeksInAY |  | numeric(4, 1) | YES |
RefCreditHoursInAY |  | numeric(7, 2) | YES |
TermsToPackageDL |  | varchar(max) | NO |
IsAllowProrateDL |  | bit | NO |
FaPellCOAReferenceId |  | int | YES |
ExcludeFromMTF |  | bit | NO |
BooksSuppliesInst |  | bit | NO |
RoomBoardInst |  | bit | NO |
TravelInst |  | bit | NO |
OtherAmount9 |  | numeric(19, 4) | YES |
OtherAmount10 |  | numeric(19, 4) | YES |
OtherAmount11 |  | numeric(19, 4) | YES |
OtherDescrip9 |  | nchar(40) | YES |
OtherDescrip10 |  | nchar(40) | YES |
OtherDescrip11 |  | nchar(40) | YES |
OtherInst9 |  | bit | NO |
OtherInst10 |  | bit | NO |
OtherInst11 |  | bit | NO |
TuitionLock |  | bit | NO |
BookSuppliesLock |  | bit | NO |
RoomBoardLock |  | bit | NO |
TravelLock |  | bit | NO |
BankFeesLock |  | bit | NO |
Other1Lock |  | bit | NO |
Other2Lock |  | bit | NO |
Other3Lock |  | bit | NO |
Other4Lock |  | bit | NO |
Other5Lock |  | bit | NO |
Other6Lock |  | bit | NO |
Other7Lock |  | bit | NO |
Other8Lock |  | bit | NO |
Other9Lock |  | bit | NO |
Other10Lock |  | bit | NO |
Other11Lock |  | bit | NO |
BooksSuppliesDescrip |  | nvarchar(40) | YES |
RoomBoardDescrip |  | nvarchar(40) | YES |
TravelDescrip |  | nvarchar(40) | YES |
TuitionDescrip |  | nvarchar(40) | YES |
FromAYTrack |  | bit | NO |
IsInterssesionAdjustable |  | bit | NO |
PellCostOfAttendLTHT |  | money | YES |
IsHousingStatusUpdated |  | bit | NO |

FaStudentAY Primary and Unique Keys

Key Name | Key Type | Keys
FaStudentAY_FAStudentAYID_U_C_IDX | PrimaryKey | FAStudentAYID

FaStudentAY Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdEnroll | Non-Identifying | One To Zero or More | FK_FaStudentAY_AdEnrollID_AdEnroll_AdEnrollID |  |  | AdEnrollID | NO | YES
FaPackStatus | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAY_AwardYear2FAPackStatusID_FaPackStatus_FaPackStatusID |  |  | AwardYear2FAPackStatusID | NO | YES
FABudget | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAY_FaBudgetID_FABudget_FABudgetID |  |  | FaBudgetID | NO | YES
FaPackStatus | Non-Identifying | One To Zero or More | FK_FaStudentAY_FaPackStatusID_FaPackStatus_FaPackStatusID |  |  | FaPackStatusID | NO | YES
AdAttStat | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAyAutoAwardAdAttStatId_AdAttStatAdAttStatId |  |  | AutoAwardAdAttStatId | NO | YES
FaAutoAwardPopulationConfiguration | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAyFaAutoAwardPopulationConfigurationId_FaAutoAwardPopulationConfigurationFaAutoAwardPopulationConfigurationId |  |  | FaAutoAwardPopulationConfigurationId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaAwardLetterQueue | Non-Identifying | One To Zero or More | FK_FaAwardLetterQueue_FaStudentAYID_FaStudentAY_FaStudentAYID |  |  |  | NO | YES
FaHousingStatusBannerDismissedByStaff | Non-Identifying | One To Zero or More | FK_FaHousingStatusBannerDismissedByStaff_FaStudentAYId_FaStudentAY_FaStudentAYId |  |  |  | NO | YES
FaPackStatusQueue | Non-Identifying | One To Zero or More | FK_FaPackStatusQueue.FaStudentAYID_FaStudentAY.FaStudentAYID |  |  |  | NO | YES
FaStudAyDlDateReview | Non-Identifying | One To Zero or More | FK_FaStudAyDlDateReview_FaStudentAYID_FaStudentAY_FaStudentAYID |  |  |  | NO | YES
FaStudentAid | Non-Identifying | One To Zero or More | FK_FaStudentAid_FaStudentAYID_FaStudentAY_FAStudentAYID |  |  |  | NO | YES
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanHistory_FaStudentAY_FaStudentAYId |  |  |  | NO | YES
FaStudentAYComment | Non-Identifying | One To Zero or More | FK_FaStudentAYComment_FaStudentAYID_FaStudentAY_FaStudentAYID |  |  |  | NO | YES
FaStudentAYPaymentPeriod | Non-Identifying | One To Zero or More | FK_FaStudentAYPaymentPeriod_FaStudentAYID_FaStudentAY_FaStudentAYID |  |  |  | NO | YES
FaStudentMaster | Non-Identifying | One To Zero or More | FK_FaStudentMasterRequestingFaStudentAyId_FaStudentAyFaStudentAyId |  |  |  | NO | YES
HSStudentLeaseHistory | Non-Identifying | One To Zero or More | FK_HsStudentLeaseHistoryFaStudentAYID_FaStudentAYFaStudentAYID |  |  |  | NO | YES
SyAudit_FaStudentAY | Non-Identifying | One To Zero or More | FK_SyAudit_FaStudentAY_RecordID_FaStudentAY_FAStudentAYID |  |  |  | NO | YES
SyAudit_FaStudentAYPaymentPeriod | Non-Identifying | One To Zero or More | FK_SyAudit_FaStudentAYPaymentPeriod_FaStudentAyId_FaStudentAY_FaStudentAYId |  |  |  | NO | YES

FaStudentAY Check Constraints

Check Constraint Name | CheckConstraint

FaStudentAY Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

FaStudentAY Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAcademicYear | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentAY | NO |  |  |

FaStudentAY Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | RefundCalculation
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaStudentAY Data Movement Rules

Name | Type | Rule Text/Value